

CREATE TABLE FLW_LIC_DATABASECHANGELOGLOCK (ID INTEGER NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_FLW_LIC_DATABASECHANGELOGLO PRIMARY KEY (ID));

DELETE FROM FLW_LIC_DATABASECHANGELOGLOCK;

INSERT INTO FLW_LIC_DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, 0);

UPDATE FLW_LIC_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.122 (192.168.68.122)', LOCKGRANTED = TO_TIMESTAMP('2021-02-26 11:36:49.772', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0;

CREATE TABLE FLW_LIC_DATABASECHANGELOG (ID VARCHAR2(255) NOT NULL, AUTHOR VARCHAR2(255) NOT NULL, FILENAME VARCHAR2(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE VARCHAR2(10) NOT NULL, MD5SUM VARCHAR2(35), DESCRIPTION VARCHAR2(255), COMMENTS VARCHAR2(255), TAG VARCHAR2(255), LIQUIBASE VARCHAR2(20), CONTEXTS VARCHAR2(255), LABELS VARCHAR2(255), DEPLOYMENT_ID VARCHAR2(10));

CREATE TABLE FLW_LIC_LICENSE (ID_ VARCHAR2(255) NOT NULL, RESOURCE_BYTES_ BLOB, CREATION_TIME_ TIMESTAMP(6) NOT NULL, CONSTRAINT PK_FLW_LIC_LICENSE PRIMARY KEY (ID_));

INSERT INTO FLW_LIC_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'flowable', 'com/flowable/license/db/liquibase/flowable-license-db-changelog.xml', SYSTIMESTAMP, 1, '8:dba591f53fdc1240cca7f4b078fdb885', 'createTable tableName=FLW_LIC_LICENSE', '', 'EXECUTED', NULL, NULL, '3.8.0', '4339410935');

CREATE TABLE FLW_LIC_USER_LOGIN (USER_ID_ VARCHAR2(255) NOT NULL, TIMESTAMP_ TIMESTAMP(6) NOT NULL, APPLICATION_ VARCHAR2(255) NOT NULL);

INSERT INTO FLW_LIC_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2', 'flowable', 'com/flowable/license/db/liquibase/flowable-license-db-changelog.xml', SYSTIMESTAMP, 2, '8:db32ff5e89fd162412c175257e0aa8ef', 'createTable tableName=FLW_LIC_USER_LOGIN', '', 'EXECUTED', NULL, NULL, '3.8.0', '4339410935');

ALTER TABLE FLW_LIC_USER_LOGIN ADD TENANT_ID_ VARCHAR2(255);

INSERT INTO FLW_LIC_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('3', 'flowable', 'com/flowable/license/db/liquibase/flowable-license-db-changelog.xml', SYSTIMESTAMP, 3, '8:840fd3ff13278fb466cebadcfabd8ced', 'addColumn tableName=FLW_LIC_USER_LOGIN', '', 'EXECUTED', NULL, NULL, '3.8.0', '4339410935');

UPDATE FLW_LIC_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;



UPDATE FLW_CTRL_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.122 (192.168.68.122)', LOCKGRANTED = TO_TIMESTAMP('2021-02-26 11:36:51.999', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_CTRL_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

